select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (b.cnpropertyname like '%Old house in Danshui Road%' or b.enpropertyname like '%Old house in Danshui Road%') order by updateTime Desc, a.dftpic desc
High quality with full furnished, landlord will provide the bedding and towel if needed, brand new kitchen equipment, with electric lock of the gate door